﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head> 
   <title>SQL Troubleshooting help</title> 
   <!-- Template design (c) copyright 2008-2009 by Tim Green and EC Software -->
   <meta name="generator" content="Help &amp; Manual" /> 
   <meta name="keywords" content="" />
   <meta name="description" content="SQL Troubleshooting help" />
   <meta name="copyright" content="© 2012 Kentico Software" /> 
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 
   <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
   <link type="text/css" href="default.css" rel="stylesheet" /> 
   <link type="text/css" href="custom.css" rel="stylesheet" />

   <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
   <script type="text/javascript" src="jquery.scrollTo-min.js"></script>
   <script type="text/javascript" src="nsh.js"></script>



         
   <!-- CSS set with project variables and local attributes --> 
   <style type="text/css" media="screen"> 
   body { background: #fff; } 
   #breadcrumbs {width: 100%; background-color: white; border-bottom: 1px solid #000; padding: 0px 0px 5px 15px;
   margin: 3px 0; font-size: 8pt; color: #000;}
   #breadcrumbs a { color: #000; text-decoration: none;}
   #breadcrumbs a:visited { color: #000; }
   #breadcrumbs a:hover { color: #098ae2; text-decoration: none; }
   .help-url { font-size: 10pt; font-family: Arial, Verdana, Helvetica, sans-serif; 
               color: #1f84e8; text-align: center; margin: 5px 20px 10px 0px; 
               padding-top: 14px; border-top: 1px solid #000;}
   .help-url a { color: #098ae2; text-decoration: none; }
   .help-url a:visited { color: #098ae2; }
   .help-url a:hover { color: #098ae2; text-decoration: underline; }
   .highlight {background: #ffff40;}
   .breadhead {padding: 5px 0px 0px 0px !important;}    
   #innerdiv   
   {   
   padding-left: 5px;
   }
   

   </style> 

<!-- Adjustment for IE -->
<!--[if lte IE 8]>
<style type="text/css">
.topichead { padding-right: 0; }
   
   
   	.breadhead {
	margin: 0;
	padding-right: 5px;
	}
   
   
</style>
<![endif]-->
   
<script type="text/javascript">
// Initialize the page 
addEvent(window, "load", nsrInit);
addEvent(window, "load", doResize);
addEvent(window, "resize", doResize);
addEvent(window, "load", toggleJump);

</script>


<script type="text/javascript">
function mailFB_custom() {
var headerText = unQuot("Feedback on: Kentico CMS 6.0 Context Help - SQL Troubleshooting help".replace('&nbsp;',''));
var fb1 = "mailto:" + escape('Kentico Support Team <support@kentico.com>') + "?subject=" + headerText;
var titlePath = unQuot("Database setup &gt; SQL Troubleshooting help /");
var fb2 = "&body=Ref:%20" + titlePath + "%20ID:%20SQLError%0A%0D%0A%0D" + unQuot("Dear Support Staff,") + "%0A%0D%0A%0D";
var fb = fb1 + fb2;
document.location.href=fb;
}
</script>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-105987-4']);
  _gaq.push(['_setDomainName', '.kentico.com']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>        
<script type="text/javascript" src="helpman_topicinit.js"></script>
<!-- Redirect browser to frame page if page is not in the content frame. -->
<script type="text/javascript">
<!--
if (location.search.lastIndexOf("toc=0")<=0) {
  if (parent.frames.length==0) { parent.location.href="index.html?sqlerror.htm"; }
  else { parent.quicksync('a3.6'); }
}
//-->
</script>
<script type="text/javascript" src="highlight.js"></script></head> 
<body onload="highlight();">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>
<!--ZOOMSTOP-->

<div id="printheader">
<span id="printtitle">Kentico CMS 6.0 Context Help</span><br />
<p class="p_Heading1"><span class="f_Heading1">SQL Troubleshooting help</span></p>
</div>
<div id="idheader" style="border-bottom:1px solid #000;margin:0px 0px;"> 
<table id="breadtable" border="0" cellspacing="0" cellpadding="0" width="100%"> 
  <tr >
  <td align="left" class="breadhead" >
       <p id="breadcrumbs"><a href="mode_selection.htm"
        onmouseover="document.images.main.src='home_h.gif'" 
        onmouseout="document.images.main.src='home.gif'">
        <img name="main" src="home.gif" border="0" alt="Home topic" title="Home topic" /></a> 
        
        Database setup:</p> 
  </td>
  </tr>
</table>
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="headtable"> 

<!-- Script version of NavHeader -->
  <tr id="scriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead" style="padding-left: 15px;"> 
    <p class="p_Heading1"><span class="f_Heading1">SQL Troubleshooting help</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="dbinstall_stepcollation.htm"
        onmouseover="document.images.prev.src='button_prev_h.gif'" 
        onmouseout="document.images.prev.src='button_prev.gif'">
        <img name="prev" src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="diskpermissions.htm"
        onmouseover="document.images.next.src='button_next_h.gif'" 
        onmouseout="document.images.next.src='button_next.gif'"><img name="next" src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>

   
   
   
   
   

     
   <td id="print-button" align="center" width="20" class="idnav" valign="bottom">
     <a href="javascript: print();" 
     onmouseover="document.images.printbutton.src='print_h.gif'" 
     onmouseout="document.images.printbutton.src='print.gif'"><img name="printbutton" border="0" alt="Print this topic" title="Print this topic" src="print.gif" /></a>
   </td>  
     
     

  
   <td id="mail-feedback" align="center" width="20" class="idnav" valign="bottom">
   <a href="#"
        onclick='mailFB_custom();'
        onmouseover="document.images.feedback.src='mail_h.gif'" 
        onmouseout="document.images.feedback.src='mail.gif'"><img name="feedback" src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>
<!-- End script navheader version -->

<!-- NoScript version of navheader -->

  <tr id="noScriptNavHead" valign="middle" style="height: auto;"> 
    <td align="left" class="topichead"> 
    <p class="p_Heading1"><span class="f_Heading1">SQL Troubleshooting help</span></p>

    </td>
    <td align="center" width="20" class="idnav" valign="bottom">
     <a href="dbinstall_stepcollation.htm">
        <img src="button_prev.gif" border="0" alt="Previous topic" title="Previous topic" /></a>
     
   </td>
   
   <td align="center" width="20" class="idnav" valign="bottom">
     <a href="diskpermissions.htm">
        <img src="button_next.gif" border="0" alt="Next topic" title="Next topic" /></a>
        
   </td>
   
   
   
  
   

     
     
   <td align="center" width="20" class="idnav" valign="bottom">
   <img border="0" alt="JavaScript is required for the print function" title="JavaScript is required for the print function" src="print_d.gif" />
   </td>
     
     
   
   <td align="center" width="20" class="idnav" valign="bottom">
   <a href="mailto:support@kentico.com?subject=Documentation%20feedback&body=Ref%20ID:%20SQLError%0D%0D"><img src="mail.gif" border="0" alt="Mail us feedback on this topic!" title="Mail us feedback on this topic!" /></a>
   </td>
   
   <td width="4">&nbsp;</td>
  </tr>

<!-- End noscript navheader version -->
  </table>
<div id="autoTocWrapper"></div>
</div> 

<div id="idcontent"><div id="innerdiv">
<!--ZOOMRESTART-->
<p>You may encounter problems when entering the database connection details in the first step of database setup:</p>
<p>&nbsp;</p>
<p><img src="devguide_clip0225.zoom60.png" width="735" height="574" border="0" alt="devguide_clip0225"></p>
<p>&nbsp;</p>
<p class="p_Heading2"><span class="f_Heading2">Error 1: Establishing connection to the server</span></p>
<p>&nbsp;</p>
<p>Error message:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table cellspacing="3" cellpadding="3" border="1" style="border: solid 1px #000000; border-spacing:3px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" style="border: none"><p>An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p><span style="text-decoration: underline;">Troubleshooting</span>:</p>
<p>&nbsp;</p>
<p>1. Make sure the SQL Server name or IP address is correct. In some cases, using one of the following values may help:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 7px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td>your computer name</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 7px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td>localhost</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 7px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td>127.0.0.1</td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 7px;"><table border="0" cellpadding="0" cellspacing="0" style="line-height: normal;"><tr style="vertical-align:baseline" valign="baseline"><td width="13"><span style="font-size: 10pt; font-family: 'Arial Unicode MS', 'Lucida Sans Unicode', 'Arial'; color: #000000;">&#8226;</span></td><td>(local)</td></tr></table></div><p>&nbsp;</p>
<p>2. Make sure the server has Microsoft SQL Server 2005 or 2008 installed and running.</p>
<p>&nbsp;</p>
<p>3. Make sure you are using the appropriate instance of the SQL Server in case you are using different instances of SQL Server. The instance name must be entered as myserver\myinstance (please note there's a backslash <span style="font-weight: bold;">\</span>).</p>
<p>&nbsp;</p>
<p>4. If you're using Microsoft SQL Server Express 2005 with default installation settings, the correct server name is <span style="font-weight: bold;">.\sqlexpress</span> or <span style="font-weight: bold;">computername\sqlexpress</span> .</p>
<p>&nbsp;</p>
<p>5. Make sure the access to the database server is not blocked by some firewall (the default port number for TCP/IP protocol is 1433).</p>
<p>&nbsp;</p>
<p>6. If you're using <span style="font-weight: bold;">SQL Server 2005</span> (especially the Express Edition), some protocols are disabled by default. You may need to go to <span style="font-weight: bold;">Start menu -&gt; All Programs -&gt; Microsoft SQL Server 2005 -&gt; Configuration Tools</span> on the computer where the SQL Server is installed and start <span style="font-weight: bold;">SQL Server Configuration Manager</span>. Then, go to SQL Server 2005 Network Configuration and enable the TCP/IP protocol:<br>
&nbsp;<br>
<img src="devguide_clip0137.zoom80.png" width="421" height="239" border="0" alt="devguide_clip0137"><br>
&nbsp;<br>
7. You may also need to enable the TCP/IP protocol in the <span style="font-weight: bold;">SQL Native Client Configuration -&gt; Client Protocols</span> section:<br>
&nbsp;<br>
<img src="devguide_clip0156.zoom70.png" width="381" height="209" border="0" alt="devguide_clip0156"></p>
<p>&nbsp;</p>
<p><span class="f_Heading2">Error 2: Login failed for user 'xy'</span><br>
<span class="f_Heading2">&nbsp;</span></p>
<p>Error message:</p>
<p>&nbsp;</p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 0px;"><table cellspacing="3" cellpadding="3" border="1" style="border: solid 1px #000000; border-spacing:3px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" style="border: none"><p>Login failed for user 'xy'</p>
</td>
</tr>
</table>
</div>
<p>&nbsp;</p>
<p class="p_Heading3"><span class="f_Heading3">Troubleshooting for SQL Server account</span></p>
<p>&nbsp;</p>
<p>If you're using SQL Server account with password, make sure you are using a valid user name and password. The login must be created on the server, it must be enabled and permission to connect to the server must be granted to it. You can check the user account in Enterprise Manager/SQL Server Management Studio -&gt; Server -&gt; Security -&gt; Logins:<br>
&nbsp;<br>
<img src="devguide_clip0165.zoom80.png" width="191" height="159" border="0" alt="devguide_clip0165"></p>
<p>&nbsp;</p>
<p>Also, check the <span style="font-weight: bold;">Server Properties -&gt; Security</span> dialog in Enterprise Manager/SQL Server Management Studio and make sure your server supports <span style="font-weight: bold;">SQL Server and Windows Authentication mode</span>:<br>
&nbsp;<br>
<img src="devguide_clip0894.zoom70.png" width="493" height="442" border="0" alt="devguide_clip0894"></p>
<p>&nbsp;</p>
<p class="p_Heading3"><span class="f_Heading3">Troubleshooting for Windows Authentication account</span></p>
<p>&nbsp;</p>
<p>If you're using Windows Authentication account, the situation may be a little more complex and may require you to contact your network administrator. ASP.NET applications run under some particular local or domain account. This current account is displayed on the screen:<br>
&nbsp;<br>
<img src="devguide_clip0275.png" width="577" height="45" border="0" alt="devguide_clip0275"></p>
<p>&nbsp;</p>
<p>This account must have its own login with Windows authentication in the SQL Server. You can create the login in <span style="font-weight: bold;">Enterprise Manager\SQL Server Management Studio -&gt; Security -&gt; Logins</span> and grant appropriate permissions on the server to it. If you SQL Server is located on a different machine than your web server, you may need to configure your web application so that it runs under some domain account, rather than local account so that you can the login in the remote SQL Server. </p>
<p>&nbsp;</p>
<p><span style="font-weight: bold;">If you do not succeed to configure Windows authentication</span>, you may want to enable Windows and SQL Server Authentication on your SQL Server and use SQL Server account instead. You can learn more about SQL Server authentication in the <span style="font-weight: bold;">Troubleshooting for SQL Server account</span> section earlier in this chapter.</p>
<p>&nbsp;</p>

<!--ZOOMSTOP--> 

<noscript>
<p class="help-url"><b>Help URL:&nbsp;</b><a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?sqlerror.htm" target="_top" title="Right-click to copy the URL of this help topic">
<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?sqlerror.htm</a>
</p>
</noscript>
<script type="text/javascript">
var autoURL = true;
if (autoURL) {
      document.write(getHref("index.html","Help URL:","Right-click to copy the URL of this help topic"));
      } else {
             document.write('<p class="help-url"><b>Help URL:&nbsp;</b>');
             document.write('<a href="<%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?sqlerror.htm" target="_top" title="Right-click to copy the URL of this help topic"><%HELP_LOCATION%><%DEVNET_PATH_NAME%>/index.html?sqlerror.htm</a>');
             document.write('</p>');
      }
</script>

</div></div> 
</body>
</html>





